Salesforce Connector MATH Functions

ABS(numeric_expression)

Returns the absolute (positive) value of the specified numeric expression.

SELECT ABS(15);
-- Result: 15

SELECT ABS(-15);
-- Result: 15

ACOS(float_expression)

Returns the arc cosine, the angle in radians whose cosine is the specified float expression.

SELECT ACOS(0.5);
-- Result: 1.0471975511966

ASIN(float_expression)

Returns the arc sine, the angle in radians whose sine is the specified float expression.

SELECT ASIN(0.5);
-- Result: 0.523598775598299

ATAN(float_expression)

Returns the arc tangent, the angle in radians whose tangent is the specified float expression.

SELECT ATAN(10);
-- Result: 1.47112767430373

ATN2(float_expression1, float_expression2)

Returns the angle in radians between the positive x-axis and the ray from the origin to the point (y, x) where x and y are the values of the two specified float expressions.

SELECT ATN2(1, 1);
-- Result: 0.785398163397448

CEILING(numeric_expression)

Returns the smallest integer greater than or equal to the specified numeric expression.

SELECT CEILING(1.3);
-- Result: 2

SELECT CEILING(1.5);
-- Result: 2

SELECT CEILING(1.7);
-- Result: 2

COS(float_expression)

Returns the trigonometric cosine of the specified angle in radians in the specified expression.

SELECT COS(1);
-- Result: 0.54030230586814

COT(float_expression)

Returns the trigonometric cotangent of the angle in radians specified by float_expression.

SELECT COT(1);
-- Result: 0.642092615934331

DEGREES(numeric_expression)

Returns the angle in degrees for the angle specified in radians.

SELECT DEGREES(3.1415926);
-- Result: 179.999996929531

EXP(float_expression)

Returns the exponential value of the specified float expression. For example, EXP(LOG(20)) is 20.

SELECT EXP(2);
-- Result: 7.38905609893065

EXPR(expression)

Evaluates the expression.

SELECT EXPR('1 + 2 * 3');
-- Result: 7

SELECT EXPR('1 + 2 * 3 == 7');
-- Result: true

FLOOR(numeric_expression)

Returns the largest integer less than or equal to the numeric expression.

SELECT FLOOR(1.3);
-- Result: 1

SELECT FLOOR(1.5);
-- Result: 1

SELECT FLOOR(1.7);
-- Result: 1

LOG(float_expression[, base])

Returns the natural logarithm of the specified float expression.

SELECT LOG(7.3890560);
-- Result: 1.99999998661119

LOG10(float_expression)

Returns the base-10 logarithm of the specified float expression.

SELECT LOG10(10000);
-- Result: 4

PI()

Returns the constant value of pi.

SELECT PI()
-- Result: 3.14159265358979

POWER(float_expression, y)

Returns the value of the specified expression raised to the specified power.

SELECT POWER(2, 10);
-- Result: 1024

SELECT POWER(2, -2);
-- Result: 0.25

RADIANS(float_expression)

Returns the angle in radians of the angle in degrees.

SELECT RADIANS(180);
-- Result: 3.14159265358979

RAND([integer_seed])

Returns a pseudorandom float value from 0 through 1, exclusive.

SELECT RAND();
-- This result may be different, since the seed is randomized
-- Result: 0.873159630165044

SELECT RAND(1);
-- This result will always be the same, since the seed is constant
-- Result: 0.248668584157093

ROUND(numeric_expression, integer_length[, function])

Returns the numeric value rounded to the specified length or precision.

SELECT ROUND(1.3, 0);
-- Result: 1

SELECT ROUND(1.55, 1);
-- Result: 1.6

SELECT ROUND(1.7, 0, 0);
-- Result: 2

SELECT ROUND(1.7, 0, 1);
-- Result: 1

SIGN(numeric_expression)

Returns the positive sign (1), 0, or negative sign (-1) of the specified expression.

SELECT SIGN(0);
-- Result: 0

SELECT SIGN(10);
-- Result: 1

SELECT SIGN(-10);
-- Result: -1

SIN(float_expression)

Returns the trigonometric sine of the angle in radians.

SELECT SIN(1);
-- Result: 0.841470984807897

SQRT(float_expression)

Returns the square root of the specified float value.

SELECT SQRT(100);
-- Result: 10

SQUARE(float_expression)

Returns the square of the specified float value.

SELECT SQUARE(10);
-- Result: 100

SELECT SQUARE(-10);
-- Result: 100

TAN(float_expression)

Returns the tangent of the input expression.

SELECT TAN(1);
-- Result: 1.5574077246549